﻿#///////////////////////////////////////////////////////////////////////////////////////
#///////////////////////////////Get Self   Tables///////////////////////////////////////
#///////////////////////////////////////////////////////////////////////////////////////
$filePath = "D:\Docs\数据同步\对接表数据汇总.txt";
$content = Get-Content $filePath;
$lst = $content;

$output = "";
foreach ($line in $lst)
{
   $items = $line.Split("	",[StringSplitOptions]::RemoveEmptyEntries);
   if ($items.Length -lt 3)
   {
   Write-Host $items
       #continute;
       continue;
   }
   $flag = $items[0];
    $tableName = $items[1]
   
    $output +=  ('"'+$tableName +'"'+[System.Environment]::NewLine);
}

$output >> "f:/ttt_tableNames.txt"


#///////////////////////////////////////////////////////////////////////////////////////
#//////////////////////////////////////Compare/////////////////////////////////////////
#///////////////////////////////////////////////////////////////////////////////////////
#$tableNames_xinwen = "BDC_REGN_FWSYQ_XMNDZFW_MX","BDC_REGN_GJZW","BDC_REGN_HYHD","BDC_REGN_JZWQFSYQ","BDC_REGN_LQ","BDC_REGN_LQ_PRINT","BDC_REGN_QT","BDC_REGN_TDSYQ","BDC_REGN_TDSYQ_PRINT","BDC_REGN_XMNDZFW_PRINT","BDC_REGN_YG","BDC_REGN_YG_PRINT","BDC_REGN_YY","BDC_REGN_YY_PRINT","BDC_REQ","BDC_REQ_CJF_INFO","BDC_REQ_KZXX","BDC_SDCKB","BDC_SEQNUM_CONFIG","BDC_SEQNUM_USAGE","BDC_SJSB","BDC_SLQKGZD","BDC_SLTZS","BDC_SLTZS_CL","BDC_WCFZM","BDC_WDYZM","BDC_WFZM","BDC_XMNDZFW","BDC_XMNDZFW_CD","BDC_XMNDZFW_MX","BDC_XMNDZFW_MX_CD","BDC_XZZXWS","BDC_ZDBHQK","BDC_ZDJBXX_DJ","BDC_ZDJBXX_FG","BDC_ZD_ZBXX","BDC_ZHJBXX","BDC_ZHSYZK","BDC_ZH_BHQK","BDC_ZH_ZBXX","KANQDB_DIMENSION","KANQDB_FIELD_ALIASNAME","KANQDB_SESSION_INFO","KANQDB_SPATIALREFERENCES","KANQDB_SPATIAL_DATASETS","KANQDB_SPATIAL_INDEX","KANQDB_SPATIAL_TABLES","KANQDB_TABLE_INFO","KANQDB_TABLE_LOCKS","KQDB_RCAT","KQDB_RDS","KQRASTER_COLUMNS","KQRASTER_SPATIALREF","LOCATEVIEWPOINT","MH_AFFIX_DIC","MH_AFFIX_EXTEND","MODEL","OA2_AGENT","OA2_AUTHORITY","OA2_BUSINESS","OA2_COMPLEX","OA2_COUNT","OA2_FLINK","OA2_FLOG","OA2_FTACH","OA2_FTASK","OA2_LOGIN","OA2_MAPPED","OA2_MAPREL","OA2_MAXID","OA2_MODEL","OA2_MODTREE","OA2_OGUSER","OA2_ORGAN","OA2_RECYCLE","OA2_ROLE","OA2_ROLEA","OA2_ROLEU","OA2_ROLEUA","OA2_STATE","OA2_SYSDIC","OA2_TREE","OA2_WORKDAY","SHILIANG","TEXTPOINT","USER_TREE","YHZK","ZDBHQK","ZHBHQK","BDC_C","BDC_LJZ","BDC_XM","BDC_ZRZ","BDC_ZDJBXX","GA_USERYJLB","ATT_FJGL","ATT_TJ_PICTURE","BZTF","CBJYQZD_CD","CBJYQZD_CD_JZD","CBJYQZD_CD_JZX","CBJYQZD_GD","CBJYQZD_GD_JZD","CBJYQZD_GD_JZX","CBJYQZD_LD","CBJYQZD_LD_JZD","CBJYQZD_LD_JZX","CLKZD","DGX","DJQ","DJZQ","DZDZW","FWFHT","FW_JZD","FW_JZX","SYS_IMPORT_SCHEMA_01","ATT_BGTCINFO","ATT_BGTKINFO","ATT_BGXMINFO","ATT_BGYSINFO","ATT_FJGL2","ATT_SYSNOTE","ATT_USER","ATT_XZB","ATT_ZDSXMINFO","BDC_AUD","BDC_CER","BDC_CER_PRINT","BDC_DANGAN","BDC_DCB_CBJYQ","BDC_DCB_CBJYQ_JTCY","BDC_DCB_DJ","BDC_DCB_DJ_GYZ","BDC_DCB_DJ_JTSUOYQ","BDC_DCB_DJ_JZBS","BDC_DCB_DJ_JZDZBXX","BDC_DCB_DJ_JZQZ","BDC_DCB_DJ_KJ","BDC_DCB_FW","BDC_DCB_FW_FWZK","BDC_DCB_FW_JZWQFSYQ","BDC_DCB_FW_JZWQFSYQ_XB","BDC_DCB_GJZW","BDC_DCB_HJ","BDC_DCB_LM","BDC_DJSF","BDC_DYMUB","BDC_FCXX","BDC_FWCH_REC","BDC_FWCH_SFMX","BDC_FY_DIC","BDC_FY_PZ","BDC_GG","BDC_GXJL_CHNGTRAN","BDC_GXJL_DQLDJGXB","BDC_GXJL_RECR","BDC_GZDJJGTZ","BDC_GZDJTZ","BDC_GZDJTZ_CW","BDC_GZS","BDC_GZS_CL","BDC_H_CD","BDC_H_DJ","BDC_JDS","BDC_LOGINFO","BDC_LOGTYPE","BDC_LSZHDJXX","BDC_LZD","BDC_QLR","BDC_QLRLB","BDC_QLR_YH","BDC_REC","BDC_RECF","BDC_REC_DELLOG","BDC_REC_DYXX","BDC_REC_ZDXX","BDC_REG","BDC_REGN_CBJYQ","BDC_REGN_CBJYQ_PRINT","BDC_REGN_CF","BDC_REGN_CF_PRINT","BDC_REGN_DY","BDC_REGN_DYQ","BDC_REGN_DYQ_PRINT","BDC_REGN_DY_PRINT","BDC_REGN_FWSYQ","BDC_REGN_FWSYQ_DZ","BDC_REGN_FWSYQ_DZ_XMQK","BDC_REGN_FWSYQ_PRINT","FZD","FZM","FZX","GZW","MODELDATA","MZDZW","OA2_AFFIX","OA2_FINST","OA2_FORM","OA2_SIGN","OA2_TEMPLET","OA2_USER","SGSJ","SHIYQ_JZD","SHIYQ_JZD_DC","SHIYQ_JZD_HIS","SHIYQ_JZD_ZJ","SHIYQ_JZX","SHIYQ_JZX_DC","SHIYQ_JZX_HIS","SHIYQ_JZX_ZJ","SHYQZD_DB","SHYQZD_DB_JZD","SHYQZD_DB_JZX","SHYQZD_DS","SHYQZD_DS_JZD","SHYQZD_DS_JZX","SHYQZD_DX","SHYQZD_DX_JZD","SHYQZD_DX_JZX","SUOYQ_JZD","SUOYQ_JZD_DC","SUOYQ_JZD_HIS","SUOYQ_JZD_ZJ","SUOYQ_JZX","SUOYQ_JZX_DC","SUOYQ_JZX_HIS","SUOYQ_JZX_ZJ","SYQZD_JZD","SYQZD_JZX","XZDZW","XZQ","XZQBUF","XZQJX","XZQ_ZJ","ZD_INFO_KZ","ZD_QLR","ZD_SHIYQ","ZD_SHIYQ_DC","ZD_SHIYQ_HIS","ZD_SUOYQ","ZD_SUOYQ_DC","ZD_SUOYQ_HIS","ZH","ZH_DC","ZH_HIS","ZH_JZD","ZH_JZD_DC","ZH_JZD_HIS","ZH_JZD_ZJ","ZH_JZX","ZH_JZX_DC","ZH_JZX_HIS","ZH_JZX_ZJ","ZH_ZJ","ZJ","ZJD","ZJD_JZD","ZJD_JZX","ZRZ","ZRZ_DC","ZRZ_HIS","BDC_H";
#$tableNames_my = "ZD_SHIYQ","ZD_SHIYQBF","BDC_AUD","BDC_BDCQZH_CONFIG","BDC_C","BDC_CER","BDC_CER_PRINT","BDC_DANGAN","BDC_DCB_CBJYQ","BDC_DCB_CBJYQ_JTCY","BDC_DCB_DJ","BDC_DCB_DJ_GYZ","BDC_DCB_DJ_JTSUOYQ","BDC_DCB_DJ_JZBS","BDC_DCB_DJ_JZDZBXX","BDC_DCB_DJ_JZQZ","BDC_DCB_DJ_KJ","BDC_DCB_FW","BDC_DCB_FW_FWZK","BDC_DCB_FW_JZWQFSYQ","BDC_DCB_FW_JZWQFSYQ_XB","BDC_DCB_GJZW","BDC_DCB_HJ","BDC_DCB_LM","BDC_DJSF","BDC_FCXX","BDC_FWCH_REC","BDC_FWCH_SFMX","BDC_FY_DIC","BDC_FY_PZ","BDC_GD","BDC_GG","BDC_GXJL_CHNGTRAN","BDC_GXJL_DQLDJGXB","BDC_GXJL_RECR","BDC_GZDJJGTZ","BDC_GZDJJGTZ_GZ","BDC_GZDJTZ","BDC_GZDJTZ_CW","BDC_GZS","BDC_GZS_CL","BDC_H","BDC_H_CD","BDC_H_DJ","BDC_JDS","BDC_LJZ","BDC_LJZ_OLD","BDC_LSZHDJXX","BDC_LZD","BDC_QLR","BDC_QLRLB","BDC_QLR_YH","BDC_REC","BDC_RECF","BDC_REC_DYXX","BDC_REC_ZDXX","BDC_REG","BDC_REGN_CBJYQ","BDC_REGN_CBJYQ_PRINT","BDC_REGN_CF","BDC_REGN_CF_PRINT","BDC_REGN_DY","BDC_REGN_DYQ","BDC_REGN_DYQ_PRINT","BDC_REGN_DY_PRINT","BDC_REGN_FWSYQ","BDC_REGN_FWSYQ_DZ","BDC_REGN_FWSYQ_DZ_XMQK","BDC_REGN_FWSYQ_PRINT","BDC_REGN_FWSYQ_XMNDZFW_MX","BDC_REGN_GJZW","BDC_REGN_HYHD","BDC_REGN_JZWQFSYQ","BDC_REGN_LQ","BDC_REGN_LQ_PRINT","BDC_REGN_QT","BDC_REGN_TDSYQ","BDC_REGN_TDSYQ_PRINT","BDC_REGN_XMNDZFW_PRINT","BDC_REGN_YG","BDC_REGN_YG_PRINT","BDC_REGN_YY","BDC_REGN_YY_PRINT","BDC_REQ","BDC_REQ_CJF_INFO","BDC_REQ_KZXX","BDC_SDCKB","BDC_SEQNUM_CONFIG","BDC_SEQNUM_USAGE","BDC_SLQKGZD","BDC_SLTZS","BDC_SLTZS_CL","BDC_WCFZM","BDC_WFZM","BDC_XM","BDC_XMNDZFW_CD","BDC_XMNDZFW_MX_CD","BDC_XM_OLD","BDC_XZZXWS","BDC_ZDBHQK","BDC_ZDJBXX","BDC_ZDJBXX_DJ","BDC_ZDJBXX_FG","BDC_ZD_ZBXX","BDC_ZHJBXX","BDC_ZHSYZK","BDC_ZH_BHQK","BDC_ZH_ZBXX","BDC_ZRZ","BZTF","CLKZD","DA_DACY","DA_JYGL","DA_REC","DGX","DJQ","DJZQ","DZDZW","FWFHT","FW_JZD","FW_JZX","FZD","FZM","FZX","GA_USERYJLB","GZW","JZD","JZD_DC","JZD_HIS","JZD_ZJ","JZX","JZX_DC","JZX_HIS","JZX_ZJ","KANQDB_DIMENSION","KANQDB_FIELD_ALIASNAME","KANQDB_SPATIALREFERENCES","KANQDB_SPATIAL_DATASETS","KANQDB_SPATIAL_INDEX","KANQDB_SPATIAL_TABLES","KANQDB_TABLE_INFO","KQDB_RCAT","KQDB_RDS","KQRASTER_COLUMNS","KQRASTER_SPATIALREF","MH_AFFIX_DIC","MH_AFFIX_FJ","MH_AFFIX_INFO","MZDZW","OA2_AFFIX","OA2_AGENT","OA2_AUTHORITY","OA2_COUNT","OA2_FINST","OA2_FLINK","OA2_FLOG","OA2_FTACH","OA2_FTASK","OA2_LOGIN","OA2_ORGAN","OA2_ROLE","OA2_ROLEUA","OA2_SIGN","OA2_STATE","OA2_TEMPLET","OA2_TREE","OA2_USER","SUOYQ_JZD","SUOYQ_JZD_DC","SUOYQ_JZD_HIS","SUOYQ_JZD_ZJ","SUOYQ_JZX","SUOYQ_JZX_DC","SUOYQ_JZX_HIS","SUOYQ_JZX_ZJ","TD_DANGAN","XZDZW","XZQ","XZQBUF","XZQJX","XZQ_ZJ","ZD_SHIYQ_DC","ZD_SHIYQ_HIS","ZD_SUOYQ","ZD_SUOYQ_DC","ZD_SUOYQ_HIS","ZH","ZH_DC","ZH_HIS","ZH_JZD","ZH_JZD_DC","ZH_JZD_HIS","ZH_JZD_ZJ","ZH_JZX","ZH_JZX_DC","ZH_JZX_HIS","ZH_JZX_ZJ","ZH_ZJ","ZJ","ZRZ","ZRZ_DC","ZRZ_HIS";

#Compare-Object $tableNames_xinwen $tableNames_my

